JOB ID : 2440 L4
Location : NYC
Duration : 12+ months
Title : Python Developer with exp in ETL, Automation, Unix, Shell scripting, Autosys/Jenkin, CI/CD, Databases at NYC 12+ months cont
Description:
Hybrid 2-3 days a week onsite
Required Skills :
- 5+ Hands on Experience in Python, Unix or Shell Scripting
- Experience in Job schedular : Autosys/jenkin
- Usage of Code Repository : GIT/Perforce/CVS
- CI/CD & Automation of Build/Test/Deploy
- Experience in Jenkin job usage and build.
- Hands on experience with XML/JSON/YAML processing
- Interested in learning database technologies like Teradata/snowflake
Good To Have :
- Hands on in any one RDBMS : Teradata/ Snowflake will be added advantage
- Having Cloud based database experience is added advantage
- Awareness of IntelliJ/eclipse editor tool
- Experience in Database ETL Concepts
- Experience in Database Utilities like data export/load & object migrations.
- Experience in Application/Database Migration activities.
- Java programming will be an added advantage
- SQL Performance Review Techniques will be added advantage
Job Description :
Being part of Finance Infrastructure group, will be responsible of centric database infrastructure supporting multiple application teams in various activities listed below :
- Support daily operations through the use of automation
- Build culture of Continuous Delivery for a better all-around software development and deployment experience
- Automation of Database Management Activities
- Automation of Migrating the database objects to higher environments in Teradata & Greenplum
- Monitoring the database system Metrics
- Automating the Generating of database Plant Usage Metrics
- Database regular cleanup & generating alerts on the maintenance activities
- Automation and Extending the partitions, historical data purging and archiving process
- Statistics Management daily/weekly, onetime refresh
- Automation of Space management and alert generation
- Database setup, proid permissions, database object modelling, validating the DB model standards in non-prod environment.
- Automating Object & data migration process between different Databases
- Data copy from Teradata to GreenPlum & vice versa using export/import utilities in corresponding database technologies.
- DDL Conversion from Teradata to GreenPlum
- Automation of Performing Benchmark tests with database/application migrations